﻿CREATE TABLE [flcr].[DEVICE_PLATFORM] (
    [DEVICE_PLATFORM_ID] INT             IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]         VARCHAR (100)   NOT NULL,
    [AUDIT_DTTM]         DATETIME        NOT NULL,
    [AUDIT_DTTM_TZ]      INT             NOT NULL,
    [AUDIT_MOD_USER]     VARCHAR (100)   NOT NULL,
    [AUDIT_MOD_DTTM]     DATETIME        NOT NULL,
    [AUDIT_MOD_DTTM_TZ]  INT             NOT NULL,
    [BUILTIN]            BIT             NOT NULL,
    [WRKFL_ITEM_ID]      INT             NOT NULL,
    [WRKFL_STATUS_ID]    INT             NOT NULL,
    [ACTIVE_FLG]         BIT             NOT NULL,
    [SORT_ORDER]         INT             NOT NULL,
    [SUPPLIER_ID]        INT             NOT NULL,
    [PLATFORM_NAME]      VARCHAR (100)   NOT NULL,
    [MODEL_NAME]         VARCHAR (100)   NOT NULL,
    [MODEL_NUM]          VARCHAR (100)   NOT NULL,
    [SKU_PART_NUM]       VARCHAR (100)   NULL,
    [OEM_EOL_DT]         DATE            NULL,
    [OEM_EOSUP_DT]       DATE            NULL,
    [OWNER_EOSL_DT]      DATE            NULL,
    [OWNER_PEOSL_DT]     DATE            NULL,
    [IMAGE_FILE]         VARBINARY (MAX) NULL
);

